class CreateFriendConditions < ActiveRecord::Migration
  def self.up
    create_table :friend_conditions do |t|
      t.integer :accounts_id, :null=>false
      t.string :sex ,:limit => 8
      t.string :age ,:limit => 32
      t.string :height ,:limit => 32
      t.string :weight ,:limit => 32
      t.string :emotion ,:limit => 32
      t.string :intent ,:limit => 32

      t.timestamps
    end
    add_index :friend_conditions, :accounts_id, :name=>"fk_accounts_confition"
  end

  def self.down
    drop_table :friend_conditions
  end
end
